


using System;
using SubSonic.Schema;
using System.Collections.Generic;
using SubSonic.DataProviders;
using System.Data;

namespace ModelDinhMuc.Model {
	
        /// <summary>
        /// Table: Users
        /// Primary Key: UserId
        /// </summary>

        public class UsersTable: DatabaseTable {
            
            public UsersTable(IDataProvider provider):base("Users",provider){
                ClassName = "User";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("UserId", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("Password", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("Email", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 100
                });
                    
                
                
            }
            
            public IColumn UserId{
                get{
                    return this.GetColumn("UserId");
                }
            }
            				
   			public static string UserIdColumn{
			      get{
        			return "UserId";
      			}
		    }
           
            public IColumn Password{
                get{
                    return this.GetColumn("Password");
                }
            }
            				
   			public static string PasswordColumn{
			      get{
        			return "Password";
      			}
		    }
           
            public IColumn Email{
                get{
                    return this.GetColumn("Email");
                }
            }
            				
   			public static string EmailColumn{
			      get{
        			return "Email";
      			}
		    }
           
                    
        }
        
        /// <summary>
        /// Table: Catalog
        /// Primary Key: id
        /// </summary>

        public class CatalogTable: DatabaseTable {
            
            public CatalogTable(IDataProvider provider):base("Catalog",provider){
                ClassName = "Catalog";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("id", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int64,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ParentID", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int64,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("MaCatalog", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("TenCatalog", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });
                    
                
                
            }
            
            public IColumn id{
                get{
                    return this.GetColumn("id");
                }
            }
            				
   			public static string idColumn{
			      get{
        			return "id";
      			}
		    }
           
            public IColumn ParentID{
                get{
                    return this.GetColumn("ParentID");
                }
            }
            				
   			public static string ParentIDColumn{
			      get{
        			return "ParentID";
      			}
		    }
           
            public IColumn MaCatalog{
                get{
                    return this.GetColumn("MaCatalog");
                }
            }
            				
   			public static string MaCatalogColumn{
			      get{
        			return "MaCatalog";
      			}
		    }
           
            public IColumn TenCatalog{
                get{
                    return this.GetColumn("TenCatalog");
                }
            }
            				
   			public static string TenCatalogColumn{
			      get{
        			return "TenCatalog";
      			}
		    }
           
                    
        }
        
        /// <summary>
        /// Table: DungCu
        /// Primary Key: ID
        /// </summary>

        public class DungCuTable: DatabaseTable {
            
            public DungCuTable(IDataProvider provider):base("DungCu",provider){
                ClassName = "DungCu";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("ID", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int64,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("IDCataLog", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int64,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("MaDungCu", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("TenDungCu", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 100
                });

                Columns.Add(new DatabaseColumn("DonVi", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 20
                });
                    
                
                
            }
            
            public IColumn ID{
                get{
                    return this.GetColumn("ID");
                }
            }
            				
   			public static string IDColumn{
			      get{
        			return "ID";
      			}
		    }
           
            public IColumn IDCataLog{
                get{
                    return this.GetColumn("IDCataLog");
                }
            }
            				
   			public static string IDCataLogColumn{
			      get{
        			return "IDCataLog";
      			}
		    }
           
            public IColumn MaDungCu{
                get{
                    return this.GetColumn("MaDungCu");
                }
            }
            				
   			public static string MaDungCuColumn{
			      get{
        			return "MaDungCu";
      			}
		    }
           
            public IColumn TenDungCu{
                get{
                    return this.GetColumn("TenDungCu");
                }
            }
            				
   			public static string TenDungCuColumn{
			      get{
        			return "TenDungCu";
      			}
		    }
           
            public IColumn DonVi{
                get{
                    return this.GetColumn("DonVi");
                }
            }
            				
   			public static string DonViColumn{
			      get{
        			return "DonVi";
      			}
		    }
           
                    
        }
        
        /// <summary>
        /// Table: DungCuPhucVuChuyenBay
        /// Primary Key: ID
        /// </summary>

        public class DungCuPhucVuChuyenBayTable: DatabaseTable {
            
            public DungCuPhucVuChuyenBayTable(IDataProvider provider):base("DungCuPhucVuChuyenBay",provider){
                ClassName = "DungCuPhucVuChuyenBay";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("ID", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int64,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("TenPhieuDungCu", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 200
                });

                Columns.Add(new DatabaseColumn("IDChuyenBay", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int64,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("IDCatalog", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int64,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });
                    
                
                
            }
            
            public IColumn ID{
                get{
                    return this.GetColumn("ID");
                }
            }
            				
   			public static string IDColumn{
			      get{
        			return "ID";
      			}
		    }
           
            public IColumn TenPhieuDungCu{
                get{
                    return this.GetColumn("TenPhieuDungCu");
                }
            }
            				
   			public static string TenPhieuDungCuColumn{
			      get{
        			return "TenPhieuDungCu";
      			}
		    }
           
            public IColumn IDChuyenBay{
                get{
                    return this.GetColumn("IDChuyenBay");
                }
            }
            				
   			public static string IDChuyenBayColumn{
			      get{
        			return "IDChuyenBay";
      			}
		    }
           
            public IColumn IDCatalog{
                get{
                    return this.GetColumn("IDCatalog");
                }
            }
            				
   			public static string IDCatalogColumn{
			      get{
        			return "IDCatalog";
      			}
		    }
           
                    
        }
        
        /// <summary>
        /// Table: ChiTietDungCuPhucVuChuyenBay
        /// Primary Key: IDDungCu
        /// </summary>

        public class ChiTietDungCuPhucVuChuyenBayTable: DatabaseTable {
            
            public ChiTietDungCuPhucVuChuyenBayTable(IDataProvider provider):base("ChiTietDungCuPhucVuChuyenBay",provider){
                ClassName = "ChiTietDungCuPhucVuChuyenBay";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("IDDungCuPhucVuChuyenBay", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int64,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("IDDungCu", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int64,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("SLCapChoKhachVip", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Double,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("SLCapChoKhachThuong", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Double,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("SLCapChoPhiCong", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Double,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("SLCapChoTiepVien", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Double,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CoDinh", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Boolean,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }
            
            public IColumn IDDungCuPhucVuChuyenBay{
                get{
                    return this.GetColumn("IDDungCuPhucVuChuyenBay");
                }
            }
            				
   			public static string IDDungCuPhucVuChuyenBayColumn{
			      get{
        			return "IDDungCuPhucVuChuyenBay";
      			}
		    }
           
            public IColumn IDDungCu{
                get{
                    return this.GetColumn("IDDungCu");
                }
            }
            				
   			public static string IDDungCuColumn{
			      get{
        			return "IDDungCu";
      			}
		    }
           
            public IColumn SLCapChoKhachVip{
                get{
                    return this.GetColumn("SLCapChoKhachVip");
                }
            }
            				
   			public static string SLCapChoKhachVipColumn{
			      get{
        			return "SLCapChoKhachVip";
      			}
		    }
           
            public IColumn SLCapChoKhachThuong{
                get{
                    return this.GetColumn("SLCapChoKhachThuong");
                }
            }
            				
   			public static string SLCapChoKhachThuongColumn{
			      get{
        			return "SLCapChoKhachThuong";
      			}
		    }
           
            public IColumn SLCapChoPhiCong{
                get{
                    return this.GetColumn("SLCapChoPhiCong");
                }
            }
            				
   			public static string SLCapChoPhiCongColumn{
			      get{
        			return "SLCapChoPhiCong";
      			}
		    }
           
            public IColumn SLCapChoTiepVien{
                get{
                    return this.GetColumn("SLCapChoTiepVien");
                }
            }
            				
   			public static string SLCapChoTiepVienColumn{
			      get{
        			return "SLCapChoTiepVien";
      			}
		    }
           
            public IColumn CoDinh{
                get{
                    return this.GetColumn("CoDinh");
                }
            }
            				
   			public static string CoDinhColumn{
			      get{
        			return "CoDinh";
      			}
		    }
           
                    
        }
        
        /// <summary>
        /// Table: ChuyenBay
        /// Primary Key: ID
        /// </summary>

        public class ChuyenBayTable: DatabaseTable {
            
            public ChuyenBayTable(IDataProvider provider):base("ChuyenBay",provider){
                ClassName = "ChuyenBay";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("ID", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int64,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("MaMB", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("MaBAY", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("SoPhiCong", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int64,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("SoTiepVien", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int64,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }
            
            public IColumn ID{
                get{
                    return this.GetColumn("ID");
                }
            }
            				
   			public static string IDColumn{
			      get{
        			return "ID";
      			}
		    }
           
            public IColumn MaMB{
                get{
                    return this.GetColumn("MaMB");
                }
            }
            				
   			public static string MaMBColumn{
			      get{
        			return "MaMB";
      			}
		    }
           
            public IColumn MaBAY{
                get{
                    return this.GetColumn("MaBAY");
                }
            }
            				
   			public static string MaBAYColumn{
			      get{
        			return "MaBAY";
      			}
		    }
           
            public IColumn SoPhiCong{
                get{
                    return this.GetColumn("SoPhiCong");
                }
            }
            				
   			public static string SoPhiCongColumn{
			      get{
        			return "SoPhiCong";
      			}
		    }
           
            public IColumn SoTiepVien{
                get{
                    return this.GetColumn("SoTiepVien");
                }
            }
            				
   			public static string SoTiepVienColumn{
			      get{
        			return "SoTiepVien";
      			}
		    }
           
                    
        }
        
}